Advanced parameter features

There are a variety of ways that parameters can be used within a report. This section covers some of the advanced methods of using parameters. These include:

• using multiple values
• applying conditional formatting using parameter fields
• creating a report title using a parameter fields
• specifying single or ranges of values
• incorporating a parameter into a formula
• defining sort order using parameter fields
• using the Edit Mask to define entry type and format.

To create a parameter with multiple values

1. On the Insert menu, click Parameter field.
2. Click New.
3. Enter a Name and Prompting text.
4. Select a Value type.
5. Select the Allow multiple values check box to enable more than one value to be entered into the parameter.
6. Click Set default values to determine the type of entries that are allowed to be entered.

   The Set Default dialog box appears.

7. From the Browse table drop-down list, select the table for the default values.
8. From the Browse field drop-down list, select the field for the default values.

   The values associated with this table and field appear in the Select or enter value to add: area.

9. Select the values listed, or create you own, and move them to the Default Values area using the arrow buttons.
10. Adjust the display, order, and length limit as required.
11. Click OK.